Accessing_Database_Fields

You are here: Function Reference > Database Functions > Accessing Database Fields

Accessing Database Fields

Usually the information in a database table is logically divided into records. These records typically contain one or more components called fields. In DAL, record fields will be associated together via a common DAL variable prefix name. Ability to access individual data elements is supported by using a dot (".") operator.

Here is an example:

Assume a table contains records with three fields:

In the script you will designate a prefix name for these variables when using the database functions. So you could end up with something like:

RECORD.LOANTYPE

RECORD.PAYMENT

RECORD.DUEDATE

Each field from the same record will have the same prefix name (which you can assign) concatenated with the dot operator.